Use this procedure to grant database access to the service account that you created for the Cobra Web Service.
To grant the service account access to the database:
-
Open SQL Management Studio and log in using a SYSADMIN account.
-
Expand the Security folder, right-click
Logins, and click
New Login.
-
On the Login-New screen, click
Search next to the
Login name field.
-
In the Select User or Group dialog box, perform the following:
-
Click
Locations and select
Entire Directory in the list.
-
In the
Enter the object name to select field, enter the service account user name that you created, and click
Check Names.
-
Click
OK.
-
On the Login-New screen, perform the following:
-
In the Select a page pane, click
Server Roles.
-
In the Server roles pane, select
sysadmin.
-
Click
OK to complete the process.